﻿using System;
using Microsoft.EntityFrameworkCore.Migrations;

namespace Mall.Api.Migrations
{
    public partial class 删除多余字段 : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropForeignKey(
                name: "FK_CommoditySKU_CommodityPropertyValue_CommodityPropertyValueId",
                table: "CommoditySKU");

            migrationBuilder.DropColumn(
                name: "CommodityIdPropertyValueId",
                table: "CommoditySKU");

            migrationBuilder.AlterColumn<int>(
                name: "CommodityPropertyValueId",
                table: "CommoditySKU",
                type: "int",
                nullable: false,
                defaultValue: 0,
                oldClrType: typeof(int),
                oldType: "int",
                oldNullable: true);

            migrationBuilder.UpdateData(
                table: "Brand",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(3210), new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(3213) });

            migrationBuilder.UpdateData(
                table: "Brand",
                keyColumn: "Id",
                keyValue: 2,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(3409), new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(3412) });

            migrationBuilder.UpdateData(
                table: "Brand",
                keyColumn: "Id",
                keyValue: 3,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(3413), new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(3414) });

            migrationBuilder.UpdateData(
                table: "Class",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(3764), new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(3767) });

            migrationBuilder.UpdateData(
                table: "Class",
                keyColumn: "Id",
                keyValue: 2,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(4142), new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(4145) });

            migrationBuilder.UpdateData(
                table: "Class",
                keyColumn: "Id",
                keyValue: 3,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(4146), new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(4147) });

            migrationBuilder.UpdateData(
                table: "Commodity",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(6146), new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(6153) });

            migrationBuilder.UpdateData(
                table: "CommodityProperty",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(4515), new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(4518) });

            migrationBuilder.UpdateData(
                table: "CommodityProperty",
                keyColumn: "Id",
                keyValue: 2,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(5377), new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(5382) });

            migrationBuilder.UpdateData(
                table: "CommodityProperty",
                keyColumn: "Id",
                keyValue: 3,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(5473), new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(5474) });

            migrationBuilder.UpdateData(
                table: "CommodityProperty",
                keyColumn: "Id",
                keyValue: 4,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(5476), new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(5477) });

            migrationBuilder.UpdateData(
                table: "CommodityProperty",
                keyColumn: "Id",
                keyValue: 5,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(5479), new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(5479) });

            migrationBuilder.UpdateData(
                table: "CommodityProperty",
                keyColumn: "Id",
                keyValue: 6,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(5481), new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(5482) });

            migrationBuilder.UpdateData(
                table: "CommodityProperty",
                keyColumn: "Id",
                keyValue: 7,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(5483), new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(5484) });

            migrationBuilder.UpdateData(
                table: "CommodityProperty",
                keyColumn: "Id",
                keyValue: 8,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(5485), new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(5486) });

            migrationBuilder.UpdateData(
                table: "CommodityWarehouse",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 114, DateTimeKind.Local).AddTicks(1218), new DateTime(2021, 8, 23, 21, 38, 32, 114, DateTimeKind.Local).AddTicks(1222) });

            migrationBuilder.UpdateData(
                table: "Jurisdiction",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 110, DateTimeKind.Local).AddTicks(5260), new DateTime(2021, 8, 23, 21, 38, 32, 111, DateTimeKind.Local).AddTicks(7100) });

            migrationBuilder.UpdateData(
                table: "Jurisdiction",
                keyColumn: "Id",
                keyValue: 2,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 111, DateTimeKind.Local).AddTicks(8213), new DateTime(2021, 8, 23, 21, 38, 32, 111, DateTimeKind.Local).AddTicks(8217) });

            migrationBuilder.UpdateData(
                table: "Jurisdiction",
                keyColumn: "Id",
                keyValue: 3,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 111, DateTimeKind.Local).AddTicks(8219), new DateTime(2021, 8, 23, 21, 38, 32, 111, DateTimeKind.Local).AddTicks(8220) });

            migrationBuilder.UpdateData(
                table: "Jurisdiction",
                keyColumn: "Id",
                keyValue: 4,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 111, DateTimeKind.Local).AddTicks(8221), new DateTime(2021, 8, 23, 21, 38, 32, 111, DateTimeKind.Local).AddTicks(8222) });

            migrationBuilder.UpdateData(
                table: "Jurisdiction",
                keyColumn: "Id",
                keyValue: 6,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 111, DateTimeKind.Local).AddTicks(8223), new DateTime(2021, 8, 23, 21, 38, 32, 111, DateTimeKind.Local).AddTicks(8224) });

            migrationBuilder.UpdateData(
                table: "Jurisdiction",
                keyColumn: "Id",
                keyValue: 7,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 111, DateTimeKind.Local).AddTicks(8225), new DateTime(2021, 8, 23, 21, 38, 32, 111, DateTimeKind.Local).AddTicks(8226) });

            migrationBuilder.UpdateData(
                table: "OrderStatu",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 114, DateTimeKind.Local).AddTicks(4063), new DateTime(2021, 8, 23, 21, 38, 32, 114, DateTimeKind.Local).AddTicks(4065) });

            migrationBuilder.UpdateData(
                table: "OrderStatu",
                keyColumn: "Id",
                keyValue: 2,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 114, DateTimeKind.Local).AddTicks(4262), new DateTime(2021, 8, 23, 21, 38, 32, 114, DateTimeKind.Local).AddTicks(4265) });

            migrationBuilder.UpdateData(
                table: "Payment",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 114, DateTimeKind.Local).AddTicks(3417), new DateTime(2021, 8, 23, 21, 38, 32, 114, DateTimeKind.Local).AddTicks(3420) });

            migrationBuilder.UpdateData(
                table: "Payment",
                keyColumn: "Id",
                keyValue: 2,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 114, DateTimeKind.Local).AddTicks(3615), new DateTime(2021, 8, 23, 21, 38, 32, 114, DateTimeKind.Local).AddTicks(3617) });

            migrationBuilder.UpdateData(
                table: "Payment",
                keyColumn: "Id",
                keyValue: 3,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 114, DateTimeKind.Local).AddTicks(3619), new DateTime(2021, 8, 23, 21, 38, 32, 114, DateTimeKind.Local).AddTicks(3620) });

            migrationBuilder.UpdateData(
                table: "Resource",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(2656), new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(2661) });

            migrationBuilder.UpdateData(
                table: "Resource",
                keyColumn: "Id",
                keyValue: 2,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(2854), new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(2857) });

            migrationBuilder.UpdateData(
                table: "Roles",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 112, DateTimeKind.Local).AddTicks(7470), new DateTime(2021, 8, 23, 21, 38, 32, 112, DateTimeKind.Local).AddTicks(7476) });

            migrationBuilder.UpdateData(
                table: "Roles",
                keyColumn: "Id",
                keyValue: 2,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 112, DateTimeKind.Local).AddTicks(7750), new DateTime(2021, 8, 23, 21, 38, 32, 112, DateTimeKind.Local).AddTicks(7753) });

            migrationBuilder.UpdateData(
                table: "Roles",
                keyColumn: "Id",
                keyValue: 3,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 112, DateTimeKind.Local).AddTicks(7755), new DateTime(2021, 8, 23, 21, 38, 32, 112, DateTimeKind.Local).AddTicks(7756) });

            migrationBuilder.UpdateData(
                table: "Roles",
                keyColumn: "Id",
                keyValue: 4,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 112, DateTimeKind.Local).AddTicks(7757), new DateTime(2021, 8, 23, 21, 38, 32, 112, DateTimeKind.Local).AddTicks(7758) });

            migrationBuilder.UpdateData(
                table: "RolesJurisdiction",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 112, DateTimeKind.Local).AddTicks(8167), new DateTime(2021, 8, 23, 21, 38, 32, 112, DateTimeKind.Local).AddTicks(8170) });

            migrationBuilder.UpdateData(
                table: "RolesJurisdiction",
                keyColumn: "Id",
                keyValue: 2,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 112, DateTimeKind.Local).AddTicks(8582), new DateTime(2021, 8, 23, 21, 38, 32, 112, DateTimeKind.Local).AddTicks(8585) });

            migrationBuilder.UpdateData(
                table: "RolesJurisdiction",
                keyColumn: "Id",
                keyValue: 3,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 112, DateTimeKind.Local).AddTicks(8586), new DateTime(2021, 8, 23, 21, 38, 32, 112, DateTimeKind.Local).AddTicks(8587) });

            migrationBuilder.UpdateData(
                table: "Supplier",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(8566), new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(8570) });

            migrationBuilder.UpdateData(
                table: "Users",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 112, DateTimeKind.Local).AddTicks(8966), new DateTime(2021, 8, 23, 21, 38, 32, 112, DateTimeKind.Local).AddTicks(8969) });

            migrationBuilder.UpdateData(
                table: "Users",
                keyColumn: "Id",
                keyValue: 2,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(294), new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(297) });

            migrationBuilder.UpdateData(
                table: "Warehouse",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 114, DateTimeKind.Local).AddTicks(2108), new DateTime(2021, 8, 23, 21, 38, 32, 114, DateTimeKind.Local).AddTicks(2111) });

            migrationBuilder.UpdateData(
                table: "WebsiteInfo",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(666), new DateTime(2021, 8, 23, 21, 38, 32, 113, DateTimeKind.Local).AddTicks(669) });

            migrationBuilder.AddForeignKey(
                name: "FK_CommoditySKU_CommodityPropertyValue_CommodityPropertyValueId",
                table: "CommoditySKU",
                column: "CommodityPropertyValueId",
                principalTable: "CommodityPropertyValue",
                principalColumn: "Id",
                onDelete: ReferentialAction.Cascade);
        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropForeignKey(
                name: "FK_CommoditySKU_CommodityPropertyValue_CommodityPropertyValueId",
                table: "CommoditySKU");

            migrationBuilder.AlterColumn<int>(
                name: "CommodityPropertyValueId",
                table: "CommoditySKU",
                type: "int",
                nullable: true,
                oldClrType: typeof(int),
                oldType: "int");

            migrationBuilder.AddColumn<int>(
                name: "CommodityIdPropertyValueId",
                table: "CommoditySKU",
                type: "int",
                nullable: false,
                defaultValue: 0);

            migrationBuilder.UpdateData(
                table: "Brand",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(1442), new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(1445) });

            migrationBuilder.UpdateData(
                table: "Brand",
                keyColumn: "Id",
                keyValue: 2,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(1645), new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(1648) });

            migrationBuilder.UpdateData(
                table: "Brand",
                keyColumn: "Id",
                keyValue: 3,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(1649), new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(1650) });

            migrationBuilder.UpdateData(
                table: "Class",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(2013), new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(2015) });

            migrationBuilder.UpdateData(
                table: "Class",
                keyColumn: "Id",
                keyValue: 2,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(2401), new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(2404) });

            migrationBuilder.UpdateData(
                table: "Class",
                keyColumn: "Id",
                keyValue: 3,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(2406), new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(2407) });

            migrationBuilder.UpdateData(
                table: "Commodity",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(3333), new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(3335) });

            migrationBuilder.UpdateData(
                table: "CommodityProperty",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(2752), new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(2755) });

            migrationBuilder.UpdateData(
                table: "CommodityProperty",
                keyColumn: "Id",
                keyValue: 2,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(2959), new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(2961) });

            migrationBuilder.UpdateData(
                table: "CommodityProperty",
                keyColumn: "Id",
                keyValue: 3,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(2963), new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(2964) });

            migrationBuilder.UpdateData(
                table: "CommodityProperty",
                keyColumn: "Id",
                keyValue: 4,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(2965), new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(2965) });

            migrationBuilder.UpdateData(
                table: "CommodityProperty",
                keyColumn: "Id",
                keyValue: 5,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(2967), new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(2967) });

            migrationBuilder.UpdateData(
                table: "CommodityProperty",
                keyColumn: "Id",
                keyValue: 6,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(2968), new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(2969) });

            migrationBuilder.UpdateData(
                table: "CommodityProperty",
                keyColumn: "Id",
                keyValue: 7,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(2971), new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(2972) });

            migrationBuilder.UpdateData(
                table: "CommodityProperty",
                keyColumn: "Id",
                keyValue: 8,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(2973), new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(2973) });

            migrationBuilder.UpdateData(
                table: "CommodityWarehouse",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(7876), new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(7879) });

            migrationBuilder.UpdateData(
                table: "Jurisdiction",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 760, DateTimeKind.Local).AddTicks(2478), new DateTime(2021, 8, 22, 20, 40, 27, 761, DateTimeKind.Local).AddTicks(4627) });

            migrationBuilder.UpdateData(
                table: "Jurisdiction",
                keyColumn: "Id",
                keyValue: 2,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 761, DateTimeKind.Local).AddTicks(5875), new DateTime(2021, 8, 22, 20, 40, 27, 761, DateTimeKind.Local).AddTicks(5880) });

            migrationBuilder.UpdateData(
                table: "Jurisdiction",
                keyColumn: "Id",
                keyValue: 3,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 761, DateTimeKind.Local).AddTicks(5925), new DateTime(2021, 8, 22, 20, 40, 27, 761, DateTimeKind.Local).AddTicks(5926) });

            migrationBuilder.UpdateData(
                table: "Jurisdiction",
                keyColumn: "Id",
                keyValue: 4,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 761, DateTimeKind.Local).AddTicks(5928), new DateTime(2021, 8, 22, 20, 40, 27, 761, DateTimeKind.Local).AddTicks(5929) });

            migrationBuilder.UpdateData(
                table: "Jurisdiction",
                keyColumn: "Id",
                keyValue: 6,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 761, DateTimeKind.Local).AddTicks(5930), new DateTime(2021, 8, 22, 20, 40, 27, 761, DateTimeKind.Local).AddTicks(5931) });

            migrationBuilder.UpdateData(
                table: "Jurisdiction",
                keyColumn: "Id",
                keyValue: 7,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 761, DateTimeKind.Local).AddTicks(5932), new DateTime(2021, 8, 22, 20, 40, 27, 761, DateTimeKind.Local).AddTicks(5932) });

            migrationBuilder.UpdateData(
                table: "OrderStatu",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 764, DateTimeKind.Local).AddTicks(820), new DateTime(2021, 8, 22, 20, 40, 27, 764, DateTimeKind.Local).AddTicks(823) });

            migrationBuilder.UpdateData(
                table: "OrderStatu",
                keyColumn: "Id",
                keyValue: 2,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 764, DateTimeKind.Local).AddTicks(1022), new DateTime(2021, 8, 22, 20, 40, 27, 764, DateTimeKind.Local).AddTicks(1025) });

            migrationBuilder.UpdateData(
                table: "Payment",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 764, DateTimeKind.Local).AddTicks(190), new DateTime(2021, 8, 22, 20, 40, 27, 764, DateTimeKind.Local).AddTicks(193) });

            migrationBuilder.UpdateData(
                table: "Payment",
                keyColumn: "Id",
                keyValue: 2,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 764, DateTimeKind.Local).AddTicks(390), new DateTime(2021, 8, 22, 20, 40, 27, 764, DateTimeKind.Local).AddTicks(392) });

            migrationBuilder.UpdateData(
                table: "Payment",
                keyColumn: "Id",
                keyValue: 3,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 764, DateTimeKind.Local).AddTicks(394), new DateTime(2021, 8, 22, 20, 40, 27, 764, DateTimeKind.Local).AddTicks(394) });

            migrationBuilder.UpdateData(
                table: "Resource",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(881), new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(884) });

            migrationBuilder.UpdateData(
                table: "Resource",
                keyColumn: "Id",
                keyValue: 2,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(1082), new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(1085) });

            migrationBuilder.UpdateData(
                table: "Roles",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 762, DateTimeKind.Local).AddTicks(5345), new DateTime(2021, 8, 22, 20, 40, 27, 762, DateTimeKind.Local).AddTicks(5351) });

            migrationBuilder.UpdateData(
                table: "Roles",
                keyColumn: "Id",
                keyValue: 2,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 762, DateTimeKind.Local).AddTicks(5810), new DateTime(2021, 8, 22, 20, 40, 27, 762, DateTimeKind.Local).AddTicks(5813) });

            migrationBuilder.UpdateData(
                table: "Roles",
                keyColumn: "Id",
                keyValue: 3,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 762, DateTimeKind.Local).AddTicks(5815), new DateTime(2021, 8, 22, 20, 40, 27, 762, DateTimeKind.Local).AddTicks(5816) });

            migrationBuilder.UpdateData(
                table: "Roles",
                keyColumn: "Id",
                keyValue: 4,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 762, DateTimeKind.Local).AddTicks(5817), new DateTime(2021, 8, 22, 20, 40, 27, 762, DateTimeKind.Local).AddTicks(5818) });

            migrationBuilder.UpdateData(
                table: "RolesJurisdiction",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 762, DateTimeKind.Local).AddTicks(6260), new DateTime(2021, 8, 22, 20, 40, 27, 762, DateTimeKind.Local).AddTicks(6263) });

            migrationBuilder.UpdateData(
                table: "RolesJurisdiction",
                keyColumn: "Id",
                keyValue: 2,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 762, DateTimeKind.Local).AddTicks(6826), new DateTime(2021, 8, 22, 20, 40, 27, 762, DateTimeKind.Local).AddTicks(6829) });

            migrationBuilder.UpdateData(
                table: "RolesJurisdiction",
                keyColumn: "Id",
                keyValue: 3,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 762, DateTimeKind.Local).AddTicks(6831), new DateTime(2021, 8, 22, 20, 40, 27, 762, DateTimeKind.Local).AddTicks(6832) });

            migrationBuilder.UpdateData(
                table: "Supplier",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(5182), new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(5186) });

            migrationBuilder.UpdateData(
                table: "Users",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 762, DateTimeKind.Local).AddTicks(7236), new DateTime(2021, 8, 22, 20, 40, 27, 762, DateTimeKind.Local).AddTicks(7238) });

            migrationBuilder.UpdateData(
                table: "Users",
                keyColumn: "Id",
                keyValue: 2,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 762, DateTimeKind.Local).AddTicks(8603), new DateTime(2021, 8, 22, 20, 40, 27, 762, DateTimeKind.Local).AddTicks(8607) });

            migrationBuilder.UpdateData(
                table: "Warehouse",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(8863), new DateTime(2021, 8, 22, 20, 40, 27, 763, DateTimeKind.Local).AddTicks(8866) });

            migrationBuilder.UpdateData(
                table: "WebsiteInfo",
                keyColumn: "Id",
                keyValue: 1,
                columns: new[] { "CreatedTime", "UpdatedTime" },
                values: new object[] { new DateTime(2021, 8, 22, 20, 40, 27, 762, DateTimeKind.Local).AddTicks(8999), new DateTime(2021, 8, 22, 20, 40, 27, 762, DateTimeKind.Local).AddTicks(9002) });

            migrationBuilder.AddForeignKey(
                name: "FK_CommoditySKU_CommodityPropertyValue_CommodityPropertyValueId",
                table: "CommoditySKU",
                column: "CommodityPropertyValueId",
                principalTable: "CommodityPropertyValue",
                principalColumn: "Id",
                onDelete: ReferentialAction.Restrict);
        }
    }
}
